package com.foreverwin.jzymes.production.picking.mapper;

import com.foreverwin.jzymes.production.picking.domain.Component;
import com.foreverwin.jzymes.production.picking.domain.Item;
import com.foreverwin.jzymes.production.picking.domain.PickingBillLog;
import org.apache.ibatis.annotations.Param;


import java.util.List;
import java.util.Date;


public interface PickingMapper {

    /**根据机种查找物料清单bomBo*/
    public String  selectBombo( @Param("bom") String bom );

    /**根据bomBo查找COMPONENT_GBO,QTY Bom_Component*/
    public List< Component >   selectComponent(@Param("bomBo") String bomBo );   //

    /**根据itemBo 查找 item itemdesc unit */
    public Item selectItemdata(@Param("itemBo") String itemBo);

    /**查询领料单*/
    public List<PickingBillLog>  selectPicking( @Param("site") String site  );

    /**根据requestID查找领料单*/
    public PickingBillLog selectPickingByRequestId (@Param("requestID") String resquest);

    /**根据sfc查找领料单*/
    public PickingBillLog selectPickingBySfc (@Param("sfc") String sfc,@Param("site") String site);

    /**删除原有领料单明细*/
    public void deletePickingByBillBo (@Param("billBo") String billBo);
    
}
